P04_Explore_And_Summarize_Data
2016 Presidential Campaign Financial Contributions - All Candidates
Dataset Overview
## [1] 426057 18## [1] "cmte_id" "cand_id" "cand_nm"
## [4] "contbr_nm" "contbr_city" "contbr_st"
## [7] "contbr_zip" "contbr_employer" "contbr_occupation"
## [10] "contb_receipt_amt" "contb_receipt_dt" "receipt_desc"
## [13] "memo_cd" "memo_text" "form_tp"
## [16] "file_num" "tran_id" "election_tp"## cmte_id cand_id cand_nm
## Length:426057 P00003392:184378 Clinton, Hillary Rodham :184378
## Class :character P60007168: 82523 Sanders, Bernard : 82523
## Mode :character P80001571: 78970 Trump, Donald J. : 78970
## P60006111: 29153 Cruz, Rafael Edward 'Ted': 29153
## P60006723: 20472 Rubio, Marco : 20472
## P60005915: 16074 Carson, Benjamin S. : 16074
## (Other) : 14487 (Other) : 14487
## contbr_nm contbr_city contbr_st
## LINGOR, MARGARET : 294 MIAMI : 25317 FL:426057
## MCGUINNESS, DIANE: 261 TAMPA : 14812
## SAIFF, IVAN : 259 ORLANDO : 12950
## BAILEY, ANGELA : 237 NAPLES : 12577
## NASH, SANDY : 218 SARASOTA: 11500
## STANLEY, ANTHONY : 218 (Other) :348899
## (Other) :424570 NA's : 2
## contbr_zip contbr_employer
## Min. : 3 RETIRED : 85832
## 1st Qu.:321632264 N/A : 66325
## Median :331313214 SELF-EMPLOYED : 29404
## Mean :263365576 NONE : 24707
## 3rd Qu.:336105620 INFORMATION REQUESTED: 20037
## Max. :349978929 (Other) :199488
## NA's :6 NA's : 264
## contbr_occupation contb_receipt_amt contb_receipt_dt
## RETIRED :136253 Min. :-20000.0 12-JUL-16: 6876
## NOT EMPLOYED : 33103 1st Qu.: 15.0 11-JUL-16: 6092
## INFORMATION REQUESTED: 19901 Median : 30.0 06-JUL-16: 3752
## ATTORNEY : 10115 Mean : 136.2 29-FEB-16: 3398
## PHYSICIAN : 6071 3rd Qu.: 100.0 19-JUL-16: 3106
## (Other) :220553 Max. : 20000.0 31-OCT-16: 3097
## NA's : 61 (Other) :399736
## receipt_desc memo_cd
## :418057 :324252
## Refund : 3720 X:101805
## REDESIGNATION FROM PRIMARY: 999
## REDESIGNATION TO GENERAL : 998
## REATTRIBUTION TO SPOUSE : 456
## REATTRIBUTION FROM SPOUSE : 450
## (Other) : 1377
## memo_text form_tp
## :306323 SA17A:325018
## * EARMARKED CONTRIBUTION: SEE BELOW: 80368 SA18 : 97319
## * HILLARY VICTORY FUND : 32992 SB28A: 3720
## REDESIGNATION FROM PRIMARY : 999
## REDESIGNATION TO GENERAL : 998
## EARMARKED FROM MAKE DC LISTEN : 532
## (Other) : 3845
## file_num tran_id election_tp
## Min. :1003942 A587D73F5F36B4479B05: 5 : 1244
## 1st Qu.:1077916 A0C59999978424AC4931: 4 G2016:153073
## Median :1104813 AE049043E90AB4BB8A37: 4 O2016: 54
## Mean :1100867 A59887ABCE6F64A2EB91: 3 P2016:271685
## 3rd Qu.:1133832 AABA56134F3604F6786A: 3 P2020: 1
## Max. :1146285 C11848970 : 3
## (Other) :426035Our dataset consists of 18 variables, with almost 426,057 observations.
Let us see some sample data
## cmte_id cand_id cand_nm contbr_nm contbr_city
## 1 C00580100 P80001571 Trump, Donald J. SELLAS, KRISTEN CLEARWATER
## 2 C00580100 P80001571 Trump, Donald J. SELLERS, CHRIS VERO BEACH
## contbr_st contbr_zip contbr_employer
## 1 FL 33759 RETIRED
## 2 FL 32966 PROST BEVERAGE COMPANY LLC
## contbr_occupation contb_receipt_amt contb_receipt_dt
## 1 RETIRED 68.37 09-NOV-16
## 2 BEVERAGE INDUSTRY EXECUTIVE 80.00 19-NOV-16
## receipt_desc memo_cd memo_text form_tp file_num tran_id election_tp
## 1 X SA18 1146165 SA18.145176 G2016
## 2 X SA18 1146165 SA18.120235 G2016According FEC.gov : Individual’s contribution limit is $2700 so I’ll eliminate any negative amounts (refunds) and amounts that exceed the contribution’s limit .
## [1] 417573 18## cmte_id cand_id cand_nm contbr_nm
## 1 C00580100 P80001571 Trump, Donald J. SELLAS, KRISTEN
## 2 C00580100 P80001571 Trump, Donald J. SELLERS, CHRIS
## 3 C00575795 P00003392 Clinton, Hillary Rodham SCHECTER, MITCHELL
## 4 C00577130 P60007168 Sanders, Bernard LERBS, CHRISTOPHER
## 5 C00575795 P00003392 Clinton, Hillary Rodham CHOREY, LORI
## 6 C00580100 P80001571 Trump, Donald J. PUSINS, AUDREY
## contbr_city contbr_st contbr_zip contbr_employer
## 1 CLEARWATER FL 33759 RETIRED
## 2 VERO BEACH FL 32966 PROST BEVERAGE COMPANY LLC
## 3 PLANTATION FL 333243808 TERRANOVA
## 4 GREEN COVE SPRINGS FL 320433443 NONE
## 5 TALLAHASSEE FL 323121800 SWEAT THERAPY FITNESS
## 6 BOCA RATON FL 33433 PBSO
## contbr_occupation contb_receipt_amt contb_receipt_dt
## 1 RETIRED 68.37 09-NOV-16
## 2 BEVERAGE INDUSTRY EXECUTIVE 80.00 19-NOV-16
## 3 CONTROLLER 15.00 22-APR-16
## 4 NOT EMPLOYED 50.00 05-MAR-16
## 5 FITNESS TRAINER 100.00 06-APR-16
## 6 LAW ENFIRCEMENY 76.89 02-DEC-16
## receipt_desc memo_cd memo_text form_tp
## 1 X SA18
## 2 X SA18
## 3 X * HILLARY VICTORY FUND SA18
## 4 * EARMARKED CONTRIBUTION: SEE BELOW SA17A
## 5 X * HILLARY VICTORY FUND SA18
## 6 X SA18
## file_num tran_id election_tp
## 1 1146165 SA18.145176 G2016
## 2 1146165 SA18.120235 G2016
## 3 1091718 C4746745 P2016
## 4 1077404 VPF7BKX6F26 P2016
## 5 1091718 C4682258 P2016
## 6 1146165 SA18.133502 G2016Univariate Plots Section
Exploring recieved contribution amount
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.15 19.00 35.00 144.60 100.00 2700.00
From above, We can see about 120,000 contributor donated about less $145 .
Hillary clinton recieved highest contribution number with almost 190,000 contribution. Bernie sanders roughly reciedved 80,000 contribution, followed closely by Donland Trump with about 76,000 contribution.
Let’s see how much in total each of candidates recieved overall :
Hillary Clinton earned the lion’s share of recieved contribution amount among other candidates by recieving almost $22,500,000 M. What surprised me here is that Jeb Bush who had few thousands contrintuons got way a lot of money comparing to other candidates who had better contribtuiobns numbers such as Bernie sanders and Marco Rubio.
Boxplot would give us a better visulization about how recived contribtuion amount distributed across candidates : 
We have a lot of outliers, Our boxplo needs some tweaks to make it more readable : 
Let’s the average contribution amount for each candidates : 
Now, I’m going to explore top 10 cities with most contribution number/amount :
Looking at our barchart, I was surprised that Jacksonville wasn’t the city with highest contribution number since it’s the largest city in Florida. Seeing Miami, Tampa and Orlando among the top 5 made a lot of sense. However, I was a bit shocked that Naples slightly surpassed Jacksonville. One justification I could think of is that Naples is considered of the richest cities in Florida state.
Interestingly, two small cities Naples and Boca Raton had significant contribution comparing to other large cities such as Orlando and Jacksonville.
Bivariate Plots Section
Exploring contribtuin amount and contributin date :
Let’s see how contribution is distrubted across years
I expected 2016 to have highest contribution amount mean comparing to other years, since it’s the election year and presidential race gets closer as we approach nominees announcement date. However, data proved me wrong as I clearly see 2014 has the highest contribtuon amount mean .
Let me explore election year (2016) further : 
Let’s see monthly sum/mean/median of contribution amount for 2016 : 
Exploring contribtuin amount and contbr_occupation :
Retireds poured a lot of moeny into the elections, marking themselves as the biggest contributors among differebt occuptaions. Way behind, comes attorneys and then homemakers in the third place.
Let us what was the mean contribtuions among those top occupations : 
Homemakers were the dark horse here by contributing about $460 on avrage. Attorneys followed with average contribution less than $400
Multivariate Plots Section
Let’s look into top 10 occupations and thier impact on two final nominees, Donald Trump and Hillary Clinton
Retireds were the most highest contributor to both nominees. Attorneys played a heavy role contribtuting way much money to Hillary comapring to fractions Donlad recieved from them.
Trump has better average recived contribtuion amount than Hillary across all top 10 occupation except Attornys. Attronys donated about $400 on average to Hillary, and about $250 on average to Trump.
Final Plots and Summary
Plot One
Rich citites in Florida played major role contributing to candidates. We can see how rich, small cities liek Naples and Boca Raton have more i mpact than major cities such as Jacksonville.
Plot Two
Contributin amounts started going up somewhere aroud Septmeber, reaching the peak in October and then started decreasing toward election month, Nov.
Plot Three
Hillary topped Trump in all top 10 occuptins.
Reflection
Florida state 2016 election contribution dataset contains more than 417573 items which were captured between 2013-10-01 and 2016-12-31. To begin, I omitted contribution above FEC limit which is $2700, and any refunes.
The average contribuion was around $145, and the minimum recieved contribution was $0.15.
Most of the contribution was made to hillary clinton, bernie sanders and Donland Trump respectivly.
Contributors from Miami, Tampa and Naples contributed the major portion of recived money.
On average, contribution amount was about $300 in 2014 which was best avergae contributon comparing to other years.
Retireds, attorneys and homemakers were major players by contriuting most of the moeny recived. On average, homemakers donated about $460 and attoreys about $390 .
Candidate Benjamin carson recived the lowest contribution overall in Florida, and most of the contribution he recieved was from retireds.
It’d be very interesting to look how condidates performed in other swing states. Further, explore contribution based on the candidate’s party and his/her background.